Hi all,
I have this attached excel file I'm working with. As you can see, the Phases and Status of are broken out into separate columns, one for each phase and each status associated. I was hoping to consolidate all of the Phases into 1 column and all of the Status columns into one other column. I've been trying to work with the Transform tool, but I must be doing something wrong. I consolidated all Phases into one column, with the ID detail repeated 4 times, which is what I want. However, when I try bringing in the Status column to do the same, I have each Phase repeat 4 times as well for each of the Status columns if that makes sense? I would like to do this similar exercise with both Date fields I have as well. I feel like this should be quite simple, but I'm having issues getting there. Anyone have any insight?
Solved! Go to Solution.
@ramatp30 This is exactly what I need! If I have other columns that have maybe 2 or 3 that need to be combined in one, I'm assuming I can do the same thing for those even though I'll have more renames and joins occurring for other columns? For example, in my real data I have 15 columns I am combining into one using this method. But I also have 5 separate columns that also need to be combined into one column. Can I rename those 5 columns using the same Select tools I am using for the 15 other columns and join together?
@garthheward The phases are not always the same, they are different in each column and for each record
This worked perfect! Thanks so much @ramatp30!