Looking for a free software/tool to perform analysis on excel data....

[enggrahul78]

I have data in excel sheet. Lets say 3 columns. The data is 60% same in all 3 columns but with different name. I want to map data using drag/drop/connections (something like we do when we create ERD's) and i want the tool to present me the mapped data.

Refer attached figure. Looking forward for any tools/software which can do this for me.

I/P Data -

Topic 1		Topic 2		Topic 3
Item A		Item X		Item 55_1
Item B		Item A_1		Item A_2
Item C		Item Z		Item zz
Item D		Item E_1		Item vvv
Item E		Item 55		Item E_2
Item F
Item G

Output Data -

Item A	Item A_1	Item A_2
Item E	Item E_1	Item E_2
NA	Item 55	Item 55_1Drag and Drop.jpg

Drag and Drop.jpg

[Rob342]

Have you looked at Power BI
you can download from MS as a freebe also there is book you can download from Amazon
Rob