Extracting date from one cell and copying that value down into a new column

[casey893]

I am extracting spreadsheets from a folder. All of the spreadsheets are in the same format. I am then aggregating all of the data together to make a database.

I have a date that is in one cell in the spreadsheet (same cell throughout the entire folder). I would like to extract the date, make a new column out of it, and copy down the value 65 times. 

I tried using the transpose tool, but it misaligns the rest of the dataset. I have attached what I have so far. 

[binuacs]

@casey893 would you be able to provide a sample file and expected result

[RobertOdera]

Hi, @casey893 

A sample file will go a long way 😎

However, looking at your workflow, I do not show any Transpose Tool in use...

Else, are you trying to append the Date as an additional column using the Append Tool?

[ArnaldoSandoval]

Hi @casey893 

This post may help you to get your questions answered faster Get Answers Fast keep in mind our time is limited and althought your problem/challenge is clear to you, it is not for us.

Hope this helps
Arnaldo
Get Answers FAST (some ideas to get your questions quickly answered)

[casey893]

Hi @RobertOdera ,

I have the transpose tool disconnected right now because I am trying out alternative methods, but at one point it was connected. I will put together some dummy data.