Forum Discussion
Solved
Repeat a value for every matching cell in another column?
Hi folks! Could someone please, please advise me on how to do the following? I have data from a couple of CSV files brought in by the Get Data > Folder method. In the resulting table, I need ...
- I'm not suggesting getting rid of any rows in your main table. Surely the rows with no quote number currently are nulls - I'm suggesting duplicating your current query and reducing to one quote number per ticket number so you can use that as a lookup table to fill in the gaps on your main query.
Load a second copy of the table and filter out all the null rows. Save that as a connection. Then go back to the original query and merge with the new query and expand out the Quote number column - should match with every possible row. Then delete the original Quote no column.
Hi Savia ,
I think I get what you are suggesting, but I don't have any null rows. I need to keep all those duplicated ticket numbers. There is a primary key elsewhere in the table.
- I'm not suggesting getting rid of any rows in your main table. Surely the rows with no quote number currently are nulls - I'm suggesting duplicating your current query and reducing to one quote number per ticket number so you can use that as a lookup table to fill in the gaps on your main query.
Savia Oh, I understand!
So yes, I now have a duplicate of the source, filtered to show only entries with that quote number. A lookup table, as you say.
So, no more merging? I was a bit lost in your first reply when you said "expand out the Quote number column - should match with every possible row", I don't know how to do that!
- So in your original query, you can merge it with the new lookup table (based on the ticket number columns). That should add a 'Table' column to your original table which you can then expand to show the Quote Number column matches. That's the column you want and you can delete the original after that.