How can I reorganize the text file content for DB import

[ckwong99]

Dear Madam / Sir,

My Boss need to reorganize the text file ready for DB import, here show you the requirment and seems not difficult but how to make it by Excel2010 effectively.

FILE1 :
user1,location1,location2,locatoin3,seat1,seat2,seat3
user2,location1,seat1
user3
user4,location1,location2,seat1,seat2

After FILE1 conversion, it become as FILE2

FILE2 :
user1,location1,seat1
user1,location2,seat2
user1,location3,seat3
user2,location1,seat1
user3
user4,location1,seat1
user4,locatoin2,seat2

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[jindon]

Assuming every line has complete pair of location# and seat# in order.

Please Login or Register  to view this content.

[ckwong99]

Hi Jindon,

Glad to see your answer.

I got a nice result for my BOSS.

Thank you, great job