Replace all values in Column 1 with the name of Column 2

[Samuel_K]

Hi all,

could you please help to solve the case.

Many Thanks in advance

Samuel

[binuacs]

@Samuel_K One way of doing this

[danilang]

Hi @Samuel_K 

Here's a completely different way to do it.  It uses the meta data as extracted by the File Info tool to populate The Date field.  This avoids the time consuming and potentially messy Transpose/Crosstab cycle.

Dan