Data transformation - Inserting a new row

[RajatRehria]

Hi guys,

I have a data like below with multiple columns showing only single column), i want to insert a row below the red highlighted line and paste whatever in the above red highlighted row in the new inserted row (refer desired Output below). Kindly help if possible. Thanks

Assets

Investments at fair value (cost of $9,252,145)

Compliance cash

Cash and cash equivalents

Liabilities and partners' capital

Liabilities:

Accounts payable

Withholding taxes payable

Payable to affiliate

Partners' capital:

net capital contributions

Required Output

Assets

Investments at fair value (cost of $9,252,145)

Investments at fair value (cost of $9,252,145)

Compliance cash

Cash and cash equivalents

Liabilities and partners' capital

Liabilities:

Accounts payable

Withholding taxes payable

Payable to affiliate

Partners' capital:

net capital contributions

[Prometheus · Accepted solution]

@RajatRehria I used the Sample tool twice to take only the first row, then unioned them and the rest of the data after I used a Sample tool to skip the first row. If the value you want to duplicate is always going to be in the first row, you can use this method.

 

 

 

[caltang · Accepted solution]

I don't know the full nature of your request, but for your use case here, you can do something like this:

The concept is to get it sorted, then you can union them according to your preferred arrangement. 

[RajatRehria]

Many thanks @caltang and @Prometheus for the solution