Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,066
- Office Version
- 2016
- Platform
- Windows
Hi
I’m a really stuck, I have a category list in EXCEL. I have a 35 categories, each with sub categories and each sub categories has further sub categories, a total of 6 levels. The amount of data I have to input manually is in about 15164 lines, over 6 columns.
Level 1 = 35
Level 2 = 587
Level 3 = 4995
Level 4 = 7243
Level 5 = 2183
Level 6 = 121
I can use a plugin to upload them to my website however, the data needs to be in each row to do this, so i need to take this data form 15000+ line and convert it so it has all in single rows. I have attached a link to what i am looking for,
https://app.box.com/s/jkvmilgl47i0uxbyxjnv5p0piule6scs
I am really stuck on this one, So far I have been inputting them by hand and it is taking forever. Can this be done with a code.
I’m a really stuck, I have a category list in EXCEL. I have a 35 categories, each with sub categories and each sub categories has further sub categories, a total of 6 levels. The amount of data I have to input manually is in about 15164 lines, over 6 columns.
Level 1 = 35
Level 2 = 587
Level 3 = 4995
Level 4 = 7243
Level 5 = 2183
Level 6 = 121
I can use a plugin to upload them to my website however, the data needs to be in each row to do this, so i need to take this data form 15000+ line and convert it so it has all in single rows. I have attached a link to what i am looking for,
https://app.box.com/s/jkvmilgl47i0uxbyxjnv5p0piule6scs
I am really stuck on this one, So far I have been inputting them by hand and it is taking forever. Can this be done with a code.
