Data Format Change in File

Question

Hi All,

My Input Data is like this

Subhasree and Nikhil are two emoployees of Company Tcs.

The Output Data should look like :

I have done it for four employees, but if I get huge data volume means more employees (may be 50).. then I need to make the workflow generalized. This is not happening. Please help.

jdunkerley79 · Accepted Answer

Hi,

I have put together a sample doing what I think you need generically.

First it transpose the data so is row based

It will copy the company name over the null values for the first row.

It then splits the header row off (row 2) and rejoins the company name to the rest of the data.

After that it uses the header row to label the data and then cross tabs the data into the form you need.

Let me know if it makes sense!

James

Subhasree · Accepted Answer

Hello, That was very helpful. Thanks so much.