Adding specific data sets for each row

[scollier1993]

Hi All,

Here's the question that I have. My file does essentially look like this: 

Person 1	XX
Person 2	YY
Person 3	ZZ

Single rows for each record. 

I now want to add specific data "blocks" to those rows, so the result would basically look like this:

Person 1	XX	123
		456
		789
Person 2	YY	123
		456
		789
Person 3	ZZ	123
		456
		789

So I'm adding the "block" with 123; 456; 789 for every single record and the added rows are blank, aside from the information in the "block".

This is done easily manually, but the set I am looking at has a couple thousand rows, so I'd obviously prefer a smarter solution 🙂

Thank you!

[echuong1 · Accepted solution]

Probably not the most effective method, but you can append the two lists together to get all combinations, then use multi-row formulas to bring the null values back. See attached for an example. Let me know if that works!

[scollier1993 · Accepted solution]

Thank you!

That pushed me in the right direction. Instead of using the multi-row formula tool, I separated my "block" data set between the first row and the remaining rows. 

First Set:

Block

123

Second Set: 

Block

456

789

I then did the Append Fields for my original file and the file with only one row, then I did the Append fields with the original file and the file that has all remaining "block" records and used the formula tool to basically empty all columns in that data set. 

Then I joined those two and sorted. 

This sounds like more work, but because I had so many fields in my file, it was easier that way because I didn't have to create 30 multi-row formula tools but was able to empty them all in one formula tool.