My data looks like this
Planned | Actual | Variance | Sum | Difference | T |
A | |||||
100 | 100 | 50 | 200 | 0 | |
1 | 3 | 4 | B | ||
6 | 4 |
The way it looks like this, its because it was a merged cell in excel. What I want to do is to join both of these rows because second row is almost entirely blank and I need both 'T' and 'A' in the same row.
Is there a way to have the data in the same cell in alteryx when uploading merged cells from excel?
If not, what would be the most suitable way to join these two rows? I've a number of rows below that I don't want to join, it's only the top two rows.
Thanks
Solved! Go to Solution.
Hi Pav,
Can you post a screen shot sharing what you'd like the data to look like?
Planned | Actual | Variance | Sum | Difference | T A |
100 | 100 | 50 | 200 | 0 | |
1 | 3 | 4 | B | ||
6 | 4 |
As you can see, the second row is gone and the letter 'A' that was there is concatenated with the first row data.
I don't mind is it separated by whitespace, comma etc. as long as it is in the same row. All the rows below stay the same.
Hope that makes it clear.
I have found that Excel is putting in a "new row" indicator.
If you use a Formula tool (or Multi-Field Formula if there are several columns with the same characteristic), you can use the expresession...
REGEX_Replace([_CurrentField_], "\n", " ")
...to replace the "new row" with a "space".
Thank you, works perfectly.