Rearranging Data
Hi,
I have 51 numbers in a row that I want to efficiently rearrange into columns in groups of three. EXAMPLE DATA Current arrangement: 1 2 3 4 5 6 7 8 9 Desired arrangement: 123 456 789 I have over 300 rows that are arranged like this and a total of 51 columns. I tried TRANSPOSE but I am not sure that is the best method. Any help is greatly appreciated! Thank You! |
All times are GMT +1. The time now is 09:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com