Avatar of Coaster_brook_trout
Coaster_brook_trout
Flag 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
Microsoft Excel

Avatar of undefined
Last Comment
nutsch

8/22/2022 - Mon
nutsch

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
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
nutsch

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Coaster_brook_trout

ASKER
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!!!!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Coaster_brook_trout

ASKER
Thanks Thomas!!!!
nutsch

Glad to help. Thanks for the kind words.

Thomas