town

I'm stuck on what I think is a simple issue and can’t seem to figure out what is needed – any help is appreciated! I am looking to take a vertical list of data and pivot only two columns into stretching across the row, while keeping only one line for each unique Customer ID. My list has about...

Hi all, I am looking to do a mail shot from a publication but need some assistance in sorting the data from a pdf. The data comes in the following format: OK1234567 R The food company Ltd Director(s) Mr Joe Blogs, Mrs Joe Blogs Unt A, Some Road, Some town, Some county, Some post code...

On the same workbook, I have Sheet 1 and Sheet 2. Sheet 1 is the master list where all business gathered go into the database with the respective towns and has 6 columns. Sheet 2 is an individualized town report where A1 will have the Town name. Sheet 1 Sheet 2 I would like to create a...

Hello Everyone, I am trying to take a list of addresses and somehow export data from that to give me some totals on the heat type. So essentially I want to take the address and simply convert it to just the town name and the totals of heat type for that town. Normally I would do this manually...

Hi, Applying FILTER in a table which included name of retail outlets and their town names. At bottom of table somewhere in a cell for a purpose I want to show "filtered" town name while apply filter on a town ... and my purpose is... I will put a "vlookup" with this to pull data from another...

Hello! Is there a way to filter multiple rows separately? my data looks like this: Town A T-B T-C Assigned 8 8 22.... - ABCa 2 6 8 - ABCb 4 0 10 - ABCa...

Dear Experts, i have 2 sheets, in 1 sheet we have different town sale and in 2nd sheet how can i put these sale into their column. please help me in this. Sheet 1 <colgroup><col><col><col><col span="7"><col><col span="3"></colgroup><tbody> SAPCODE Code SKUName ID SKUID Opening Stock Receipt...

Hi all, I could definitely use your help in addressing my code. This is the first time I've ever coded in VBA so appreciate any beginner's advice and tips. As a brief background, I have an excel sheet of my county's zip codes (col 2) and their corresponding towns (col 3). I want to have a person...

Hi all, I could definitely use your help in addressing my code. This is the first time I've ever coded in VBA so appreciate any beginner's advice and tips. As a brief background, I have an excel sheet of my county's zip codes (col 2) and their corresponding towns (col 3). I want to have a person...

Hi Folks, So I have an macro code which searches through "column C" for specific keywords and moves it to "Sheet2" the whole row if it matches the keyword. Example: I made the code to move the whole row if there is a keywords such as "town, county, city, state, etc" I did this because I have...

I have just been upgraded to excel 2016 and have stumbled on my first attempt at using power query. I have data in an excel workbook that has a couple of rows of data sitting on its own above main data set that i would like to include in table but cannot work out solution that doesn't involve...