Hi everyone,
I have a sheet where I have information that is copied over from an external source in blocks. By this I mean:
In column A I will have the title of a location;
in Col B I will have various lines of specs; Column C I will have the Country of the location in column A etc.
Looks something like this (....... represents blank cells):
LOCATION1 Spec1 Country1
.................Spec2............
.................Spec3............
LOCATION2 Spec1 Country1
.................Spec2............
.................Spec3............
This repeats for numerous but varying locations every month.
So I want it to look like this as I need to sort, count locations etc:
LOCATION1 Spec1 Country1
LOCATION1 Spec2 Country1
LOCATION1 Spec3 Country1
LOCATION2 Spec1 Country2
LOCATION2 Spec2 Country2
LOCATION2 Spec3 Country2
My question is, is it possible to automate the copying of each location and country info in the blank cells with this all being dynamic?
Thanks again as always,
Ana
I have a sheet where I have information that is copied over from an external source in blocks. By this I mean:
In column A I will have the title of a location;
in Col B I will have various lines of specs; Column C I will have the Country of the location in column A etc.
Looks something like this (....... represents blank cells):
LOCATION1 Spec1 Country1
.................Spec2............
.................Spec3............
LOCATION2 Spec1 Country1
.................Spec2............
.................Spec3............
This repeats for numerous but varying locations every month.
So I want it to look like this as I need to sort, count locations etc:
LOCATION1 Spec1 Country1
LOCATION1 Spec2 Country1
LOCATION1 Spec3 Country1
LOCATION2 Spec1 Country2
LOCATION2 Spec2 Country2
LOCATION2 Spec3 Country2
My question is, is it possible to automate the copying of each location and country info in the blank cells with this all being dynamic?
Thanks again as always,
Ana
Last edited: