mcrmg
asked on
create a new table based on another table
Hi,
Please see the file attached. I will import this into SQL. There are 4 fields:
ACCT - account number
GROUP - same note
SEQ - order in that note
I need to create a new table that can group all the notes based on ACCT, GROUP, and combine notes based on the SEQ. So for example, for 123456, there will be have 5 rows in the new table. thx
Book1.xlsx
Please see the file attached. I will import this into SQL. There are 4 fields:
ACCT - account number
GROUP - same note
SEQ - order in that note
I need to create a new table that can group all the notes based on ACCT, GROUP, and combine notes based on the SEQ. So for example, for 123456, there will be have 5 rows in the new table. thx
Book1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I use @PatelAlpesh's concept and get it done.....thanks
ASKER