Link to home
Create AccountLog in
Avatar of Coaster_brook_trout
Coaster_brook_troutFlag for United States of America

asked on

Changing flat file to relational in excel

I would like a macro to change sheet 1 to sheet 2. I don't have the first clue on how to write a macro, I am doing all of this by hand. Basically I am turning the flat file onto its side.
Help.xls
Avatar of nutsch
nutsch
Flag of United States of America image

I could have an add-in for this. Select cell E2 and run attached the Table2DB add-in with all default options. This turns the flat file on the side, but I'm not sure if you have added logic cause my result is different than yours and I don't understand the data fully.

Thomas
Table2DB.xla
Avatar of Coaster_brook_trout

ASKER

So that is awesome, but it's not doing what I need because it needs to grab the i1 and the n1 together, they go together....it's only grabbing the i1. The other issue is, I don't need the i1 unless there is an n1 after it. If there is no n1 after the i1, I consider that a null value....
ASKER CERTIFIED SOLUTION
Avatar of nutsch
nutsch
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I wish I could give out more points, this was the most excellent solution and it came so quickly and will save me hours of work everyday!!!!
Thanks Thomas!!!!
Glad to help. Thanks for the kind words.

Thomas