I have a data set with 50,000+ rows.
In col 1, I have zip codes and in col 2 I have B_Codes, in col 3 there is mem_info. For Each given zip and B_code, there are multiple values of mem_info. I want to use pivot table to analyze mem_info using zip & B_code. But the problem is: Zip code value and B_code value are only in the first row.
Eg:
Zip 1 B_Code 1 Mem_info 1a
blank blank Mem_info 1b
blank blank Mem_info 1c
blank blank Mem_info 1d
Zip 2 B_Code 2 Mem_info 2a
blank blank Mem_info 2b
blank blank Mem_info 2b
I want to copy that B_code value to all the rows in the given Zip for the given Mem_info.
I was trying using VBA's xldown function, but due to blankcells in the Zip & B_Code column, I was not able to select the entire column.
I would appreciate your help very much. I am very new to programming. Also, how do you post a sample of your data in this board ( I wanted to post that to facilitate my question). Thanks.
In col 1, I have zip codes and in col 2 I have B_Codes, in col 3 there is mem_info. For Each given zip and B_code, there are multiple values of mem_info. I want to use pivot table to analyze mem_info using zip & B_code. But the problem is: Zip code value and B_code value are only in the first row.
Eg:
Zip 1 B_Code 1 Mem_info 1a
blank blank Mem_info 1b
blank blank Mem_info 1c
blank blank Mem_info 1d
Zip 2 B_Code 2 Mem_info 2a
blank blank Mem_info 2b
blank blank Mem_info 2b
I want to copy that B_code value to all the rows in the given Zip for the given Mem_info.
I was trying using VBA's xldown function, but due to blankcells in the Zip & B_Code column, I was not able to select the entire column.
I would appreciate your help very much. I am very new to programming. Also, how do you post a sample of your data in this board ( I wanted to post that to facilitate my question). Thanks.