I have a really weird table that looks like that:I have one value in the 1:1, nothing in 1:2 (column:row). I have one value in 2:2 (nothing in 2:1 or 2:3). In fact this is the descrition of the records that are in 3:3 to 3:14. Given this I can not perform a search within the table. Because the description is located on 2 different rows....How an I reorganize my table in order to make this possible. One solution that comes to mind is to manually Copy-Paste the description in each row, but the table is huge, so if you have an idea how this couls be automatically done, it will be great. Just to summarize: I want to take the value of one column and append it to the rows right below that are empty. When Access reaches an already existing value, I wan to take it and do the same thing below.....
Rather complicated, huh?
Especially with this explanation
Rather complicated, huh?
