tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I currently have a situation where i need to combine 7 columns of data into 2 columns using only formulas?
(I can do this with VBA but we are sharing this over excel online and VBA does not work.)
so Column C has the names in it, Columns E G J L N P have the data i want to turn into one column
So in S for example I'll have the names in column C repeated 6 times, in T ill have all data in E then G, J and so on.
you can assume the Columns start at row 10 and go down to the last bit of data, every columns has same number of data in it.
Please help if you can
Thanks
Tony
I currently have a situation where i need to combine 7 columns of data into 2 columns using only formulas?
(I can do this with VBA but we are sharing this over excel online and VBA does not work.)
so Column C has the names in it, Columns E G J L N P have the data i want to turn into one column
So in S for example I'll have the names in column C repeated 6 times, in T ill have all data in E then G, J and so on.
you can assume the Columns start at row 10 and go down to the last bit of data, every columns has same number of data in it.
Please help if you can
Thanks
Tony