Adding rows

[SCK]

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

[PhilipMannering · Accepted solution]

Hi @SCK 

Would something like this help? See attached...

[SCK]

It worked, thank you so much! 🙂