Need to concatenate single column data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am struggling to get a solution where the structure is not static like below. I tried multi row formula, but it was giving a syntax error.
Conditions
1. Need the concatenated data to be in the 1st row of the sequence start. Here it is "A" in record 1, which is a key and separator from next block of data
2. It is 2 rows of data sample that needs to be brought in this format and then it has to be separated. Output 2 given below
Record # | Input | Output |
1 | A*15 | A*15|B*16|C*17|D*19|E*ab|F*45|G*def|H*DTP|I*456 |
2 | B*16 | |
3 | C*17 | |
4 | D*19 | |
5 | E*ab | |
6 | F*45 | |
7 | G*def | |
8 | H*DTP | |
9 | I*456 | |
10 | A*LE | A*LE|B*RS|C*45|D*32|E*123|F*124|G*156|I*129| |
11 | B*RS | |
12 | C*45 | |
13 | D*32 | |
14 | E*123 | |
15 | F*124 | |
16 | G*156 | |
17 | I*129 |
2nd output
Output | A | B | C | D | E | F | G | H | I |
A*15|B*16|C*17|D*19|E*ab|F*45|G*def|H*DTP|I*456 | A*15 | B*16 | C*17 | D*19 | E*ab | F*45 | G*def | H*DTP | I*456 |
A*LE|B*RS|C*45|D*32|E*123|F*124|G*156|I*129| | A*LE | B*RS | C*45 | D*32 | E*123 | F*124 | G*156 | I*129 |
Thanks
Naga
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @Naga,
attached the workflow that allows you to concatenate the data.
You need to add the multirow formula to avoid having empty rows after using the cross tab
Let me know if you have any questions
Best,
Vianney
Vianney
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @VianneyM ,
Thanks for the quick response. I got the answer for my 2nd output. however, need solution for this to get concatenated.
INput
Record # | Input |
1 | A*15 |
2 | B*16 |
3 | C*17 |
4 | D*19 |
5 | E*ab |
6 | F*45 |
7 | G*def |
8 | H*DTP |
9 | I*456 |
10 | A*LE |
11 | B*RS |
12 | C*45 |
13 | D*32 |
14 | E*123 |
15 | F*124 |
16 | G*156 |
17 | I*129 |
Output
Record # | Input | Output |
1 | A*15 | A*15|B*16|C*17|D*19|E*ab|F*45|G*def|H*DTP|I*456 |
2 | B*16 | |
3 | C*17 | |
4 | D*19 | |
5 | E*ab | |
6 | F*45 | |
7 | G*def | |
8 | H*DTP | |
9 | I*456 | |
10 | A*LE | A*LE|B*RS|C*45|D*32|E*123|F*124|G*156|I*129| |
11 | B*RS | |
12 | C*45 | |
13 | D*32 | |
14 | E*123 | |
15 | F*124 | |
16 | G*156 | |
17 | I*129 |
Thanks
Naga
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Naga,
Attached the complete solution from your input
INput
Record # | Input |
1 | A*15 |
2 | B*16 |
3 | C*17 |
4 | D*19 |
5 | E*ab |
6 | F*45 |
7 | G*def |
8 | H*DTP |
9 | I*456 |
10 | A*LE |
11 | B*RS |
12 | C*45 |
13 | D*32 |
14 | E*123 |
15 | F*124 |
16 | G*156 |
17 | I*129 |
to this output
Let me know if you have questions
Best,
Vianney
Vianney
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Similar solution using Multi-Row Formula tool. Set "A" as the key.
However, @VianneyM solution using Tile tool is the best way to avoid formula.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Awesome...solved my problem....Thank you so much
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
