Spreadsheet: 122744d1317128342-multiple-transpose-function-from-rows-into-columns-reorgdata-arrays-w1-aary-bary-wr-oary-redimpreserve-fletchy888-ef793907-sdg16
Sheet: Sheet1

101160621 | LK10001B0 |  |  |  |  | ReorgData arrays w1 Aary Bary wR Oary ReDimPreserve - fletchy888 - EF793907 - SDG16.xls |  |  |  |  |  |  |  |  |  |  | R | R
101160621 | LK2001300 |  |  |  |  | MS Office Version:Excel 2010 |  |  |  |  |  |  |  |  |  |  | 101160621 | 101160621 | 9 unique items
101160621 | LK30017B0 |  |  |  |  | Multiple transpose function from rows into columns |  |  |  |  |  |  |  |  |  |  | 101160621 | 101160691
101160621 | LK4001700 |  |  |  |  | http://www.excelforum.com/excel-general/793907-multiple-transpose-function-from-rows-into-columns.html |  |  |  |  |  |  |  |  |  |  | 101160621 | 101160692
101160621 | LK5187200 |  |  |  |  | Hi there, |  |  |  |  |  |  |  |  |  |  | 101160621 | 101160696
101160691 | [NAME] |  |  |  |  | I am looking for a method to be able to do multiple transpose function, rather than doing it seperately. |  |  |  |  |  |  |  |  |  |  | 101160621 | 101163278
101160691 | LK2000900 |  |  |  |  | I have approximately 5000 rows of data 2 columns, |  |  |  |  |  |  |  |  |  |  | 101160691 | 101166240
101160691 | LK30021A0 |  |  |  |  | that needs to be converted into 6 columns of data so hence 1000 rows. |  |  |  |  |  |  |  |  |  |  | 101160691 | 101166241
101160691 | LK4002100 |  |  |  |  | So I want to know of method of doing it all in one go rather than 1000 seperate times, as it is very time consuming. |  |  |  |  |  |  |  |  |  |  | 101160691 | 101166243
101160691 | LK5187400 |  |  |  |  | after being converted, some rows may have only 4 or upto 6 columns of data. |  |  |  |  |  |  |  |  |  |  | 101160691 | 101176043
101160692 | [NAME] |  |  |  |  | Here is it looks like now: |  |  |  |  |  |  |  |  |  |  | 101160691
101160692 | LK2000900 |  |  |  |  | 1 - LA1 |  |  |  |  |  |  |  |  |  |  | 101160692
101160692 | LK30021A0 |  |  |  |  | 1 - LA2 |  |  |  |  |  |  |  |  |  |  | 101160692
101160692 | LK4002100 |  |  |  |  | 1 - LA3 |  |  |  |  |  |  |  |  |  |  | 101160692
101160692 | LK5187400 |  |  |  |  | 1 - LA4 |  |  |  |  |  |  |  |  |  |  | 101160692
101160696 | LK10001B0 |  |  |  |  | 1 - LA5 |  |  |  |  |  |  |  |  |  |  | 101160692
101160696 | LK2001300 |  |  |  |  | 2 - LB1 |  |  |  |  |  |  |  |  |  |  | 101160696
101160696 | LK30017B0 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 101160696
101160696 | LK4001700 |  |  |  |  | 2 - LB3 |  |  |  |  |  |  |  |  |  |  | 101160696
101160696 | LK5187300 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 101160696
101163278 | LK1031500 |  |  |  |  | 2 - LB5 |  |  |  |  |  |  |  |  |  |  | 101160696
101163278 | LK2019600 |  |  |  |  | 3 - LC1 |  |  |  |  |  |  |  |  |  |  | 101163278
101163278 | LK3040400 |  |  |  |  | 3 - LC2 |  |  |  |  |  |  |  |  |  |  | 101163278
101163278 | LK4045600 |  |  |  |  | 3 - LC4 |  |  |  |  |  |  |  |  |  |  | 101163278
101163278 | LK4056000 |  |  |  |  | 3 - LC3 |  |  |  |  |  |  |  |  |  |  | 101163278
101163278 | LK5189900 |  |  |  |  | I want to change it into this format: |  |  |  |  |  |  |  |  |  |  | 101163278
101163278 | LK5189900 |  |  |  |  | 1 LA1 LA2 LA3 LA4 LA5 |  |  |  |  |  |  |  |  |  |  | 101163278
101163278 | LK5189900 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 101163278
101166240 | LK1040500 |  |  |  |  | 3 LC1 LC2 LC3 LC4 LC5 |  |  |  |  |  |  |  |  |  |  | 101163278
101166240 | LK2026600 |  |  |  |  | I thank anyone in advanced that can help with this problem alot! |  |  |  |  |  |  |  |  |  |  | 101166240
101166240 | LK3050900 |  |  |  |  | Regards |  |  |  |  |  |  |  |  |  |  | 101166240
101166240 | LK4069600 |  |  |  |  | Fletchy888 |  |  |  |  |  |  |  |  |  |  | 101166240
101166240 | LK5188300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101166240
101166241 | LK1040500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101166240
101166241 | LK2026600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101166241
101166241 | LK3050900 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101166241
101166241 | LK4069600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101166241
101166241 | LK5188300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101166241
101166243 | 5K2062600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101166241
101166243 | 5K30706B0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101166243
101166243 | LK1031900 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101166243
101166243 | LK4042000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101166243
101166243 | LK5137200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101166243
101176043 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101166243
101176043 | LK2000900 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101176043
101176043 | LK30021A0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101176043
101176043 | LK4002100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101176043
101176043 | LK5189800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101176043
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101176043