I'm analysing a large datasheet of over 80k rows. Data in ColA are grouped into sets which are separated by one empty row. Data sets vary dramatically in size which is the number of their rows.
What I need to do is:
1. to transpose each data set of ColA, in ColB,
2. to replicate the transposed cells down in the same number of cells of each set, and finally
3. to highlight each corresponding/duplicate value/cell between ColA and ColB
To make life much easier, I have attached an example file with two sheets: Sheet1 with data before processing, and Sheet2 as desired after processing
Can I get some precious assitance with this question please?
Many thanks in advance ..
T.
Bookmarks