How do I paste a data set and have it repeat each piece 10 times?
Hello,
I’m working on importing data and for one of my imports, I have to repeat most of the information in a row except for 1 cell. Is there a way to automate this, so I’m not having to paste 10 times and change that 1 cell each time?
Example – I’m looking for an easier way to go from Table 1 to Table 2 without having to manually process it.
Table 1
a
1b2
Table 2
a13a14b23b24
Hello,I’m working on importing data and for one of my imports, I have to repeat most of the information in a row except for 1 cell. Is there a way to automate this, so I’m not having to paste 10 times and change that 1 cell each time?Example – I’m looking for an easier way to go from Table 1 to Table 2 without having to manually process it.Table 1a1b2Table 2a13a14b23b24 Read More