Hi There,
Iv'e searched the forum for transpose formulas that could assist me with my query, however, I couldn't find the right answers I was looking for.
I'm looking to transpose data from Table 1 into Table 2 (see images). At present, I am doing this manually by copying and pasting as transposed data. I have a few thousand lines of data and was hoping someone could assist in either a formula or VB code solution.
Thanks in advance.
Iv'e searched the forum for transpose formulas that could assist me with my query, however, I couldn't find the right answers I was looking for.
I'm looking to transpose data from Table 1 into Table 2 (see images). At present, I am doing this manually by copying and pasting as transposed data. I have a few thousand lines of data and was hoping someone could assist in either a formula or VB code solution.
Thanks in advance.