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.
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.
(and in my defence, i didn't initially think expanding the table had duplicated the values, but i'd failed to realise that my matches for that were a few scrolls down the page)