Looping through multiple fields

[Panashe_2020]

Hello,

I have an excel file with user records in groups.

So imagine the raw data like this:

firm name, user_name1, user_add1, user_state1,

                        user_name2, user_add2, user_state2,

                        user_name3, user_add3, user_state3

I am trying to create a straight table that puts the users in a straight table that only has

firm_name, user_name, user_add, user_state.

I have figured how to do this using load statement multiple times and renaming the fields to the above but I think you can use a loop statement,

Does anyone have a working example I can use or refer to?

Thanks in advance.

A