Hello all - I have a dataset with details for over 100 clients. I have fixed 4 rows in my input but I want to insert 2 more rows across all the clients. Please help.
Input:
Client | Client Number | Data |
A | 1 | Cash |
A | 1 | Accounts Payable |
A | 1 | Accounts Receivable |
A | 1 | Inventory & COGS |
B | 2 | Cash |
B | 2 | Accounts Payable |
B | 2 | Accounts Receivable |
B | 2 | Inventory & COGS |
Output:
Client | Client Number | Data |
A | 1 | Cash |
A | 1 | Accounts Payable |
A | 1 | Accounts Receivable |
A | 1 | Inventory & COGS |
A | 1 | Completion |
A | 1 | Other FSLI |
B | 2 | Cash |
B | 2 | Accounts Payable |
B | 2 | Accounts Receivable |
B | 2 | Inventory & COGS |
B | 2 | Completion |
B | 2 | Other FSLI |
Solved! Go to Solution.
It worked, thank you so much! 🙂