Intro ProgrammingWhat is a loop? Which language is best for beginners? What is "object oreinted?" All those types of questions and more are welcome here.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Intro Programming section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
please help me to write a vba code to do the following
i need to a vba code with 1 row and 4 columns for every unique record, with the duplicates deleted(as the data in few row cells is the same) and the data that is different in all the 3 row cells of a column to be merged into a single cell.
below is the example.here each data is equivlent to data in a single cell
sri 29 fruit banana
sri 29 fruit apple
sri 29 fruit gova
mes 30 carrot veg
mes 30 radish veg
the output i want to be is as shown below
sri 29 fruit bananan
apple
gova
mes 30 carrot veg
radish
The row height should be automatically adjusted depending on the number of cells merged/combined
Chiluka, it really depends on which langauge you're working in. I can assist if you're using any version of Visual Basic,(I think you'd need to use what's called a FlexiGrid, and control the output) Please respond. liamfitz
ned vba code immediately, please help
